UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVjeTrfHHDjL7EW5Yvto1u6N+w4C1O7YD2sOk8nMlsA='
WHERE
key_id = 'ce6403f9ac26398e787424991783a788f5d7aee767675e34e07a010abc692096'
AND (
token = 'vVjeTrfHHDjL7EW5Yvto1u6N+w4C1O7YD2sOk8nMlsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)