UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EVWxn8Gs/9zqZNcy0QM4RuI9unVlt34Um5dySfnagZo='
WHERE
key_id = 'c890af372454a6b1a6b7bebf65ec6c2b5d6be96632dfffd29a7391a3c1a95ab2'
AND (
token = 'EVWxn8Gs/9zqZNcy0QM4RuI9unVlt34Um5dySfnagZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)