UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJvy8jE69oDg7L4C5VrkLm+GjRNhOYvV+lfMzobmwRs='
WHERE
key_id = 'b4d1c2f89c1f3c0ca2e723ae7fac9bc41bcc1527de1f81aef4e456c4c3d484fd'
AND (
token = 'pJvy8jE69oDg7L4C5VrkLm+GjRNhOYvV+lfMzobmwRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)