UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5YnpHGwwbmyYnCXMtQ/yLWHWlI08vQRFKZRh5ntxmrA='
WHERE
key_id = '8cb9aa0d49f851bea705892b27875cfc575def3453aa428c450c271769db3abc'
AND (
token = '5YnpHGwwbmyYnCXMtQ/yLWHWlI08vQRFKZRh5ntxmrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)