UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pMNToDe/5cUyaDmbTKMeI+saY177MxOdNK+Z9/CkNA='
WHERE
key_id = '73b5e5feb128c231b83b93cd41bf2ca57399a51b8939b0c21933b72a7b90cc20'
AND (
token = '4pMNToDe/5cUyaDmbTKMeI+saY177MxOdNK+Z9/CkNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)