UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBtTsJv81zWBpjS29RgoYnwNFPBf7s73C3vYVIksMp8='
WHERE
key_id = '16b4937c109e915b7f836a3adfd005f32df7c7dd3fdf47c892972e9fb3e03642'
AND (
token = 'xBtTsJv81zWBpjS29RgoYnwNFPBf7s73C3vYVIksMp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)