UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afXfRR53J5UqOjg3/gq17vFs+kqEOnVRAAnb4Iqo4qY='
WHERE
key_id = '6b0ed009e50c273e9224f7cdd90f378c25fb73f29eb58c8a156181eefc999f8a'
AND (
token = 'afXfRR53J5UqOjg3/gq17vFs+kqEOnVRAAnb4Iqo4qY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)