UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIXay1RN69pkMNG+REr94sMsofckyLE+yr/E29bSi2w='
WHERE
key_id = '8e55adacaaf923aebb07aebea7b18f96fb748754259c3a54f6a46c4f5fcd8e56'
AND (
token = 'mIXay1RN69pkMNG+REr94sMsofckyLE+yr/E29bSi2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)