UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iCgsSkeidISAeEujDcFJILc+8RhvRG0bFLEG87m4VI='
WHERE
key_id = '0803fc685f83a861e8cc2238ad2423692760e74b47b9fb738e3354e85ddd6313'
AND (
token = '8iCgsSkeidISAeEujDcFJILc+8RhvRG0bFLEG87m4VI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)