UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IWjdHiKcgWcluCcLw6FBeZ63fgXBPo+0XfD/gk3pqw0='
WHERE
key_id = '97694ce62f199a663ff4da612f54af17b2f3ea1c21bb0aaaf8913777a18f88b4'
AND (
token = 'IWjdHiKcgWcluCcLw6FBeZ63fgXBPo+0XfD/gk3pqw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)