UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJny+p5IXo4FcR8ioEuEgj65OLAhxSDdTZucdmuGJ0Q='
WHERE
key_id = 'afdf52186bef73f5b43ca8b02c77a1c131feff23a45e6e20e9d68bc7a1fcb3c1'
AND (
token = 'QJny+p5IXo4FcR8ioEuEgj65OLAhxSDdTZucdmuGJ0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)