UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xhsf5B/lO4L3bsHCpaQRnmseMV/7lr8HtW4ALGHanUo='
WHERE
key_id = 'df678136fd2f9a15cc46afeda4a34389ae25d4996deb1c73b4fa4d800fcc1857'
AND (
token = 'Xhsf5B/lO4L3bsHCpaQRnmseMV/7lr8HtW4ALGHanUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)