UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zJCHx/EwPZrFEBAhFnqYv0to+O+YJngHUpIAhdCmTA='
WHERE
key_id = '6238e8a396d3d1afbdef325962d6d75f50b902173170e8fb0202439a9af19b64'
AND (
token = '6zJCHx/EwPZrFEBAhFnqYv0to+O+YJngHUpIAhdCmTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)