UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hhw3F60G3kaUtvWmQPo1wV+bTu8Bb+Nm+Gkj9DeM2q8='
WHERE
key_id = '30b04f69dad9908877ca9ea957a4b67f426b1b80e393a54e25fb512ac3ac6f9c'
AND (
token = 'Hhw3F60G3kaUtvWmQPo1wV+bTu8Bb+Nm+Gkj9DeM2q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)