UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ip4fjTQIO80CexrprZ+u4GgW4SVZeoEGd0S2jg88HQw='
WHERE
key_id = 'b1c370f1e6f48b58478d5d87cfc1ed5800cc5403506068501362222f651f96f5'
AND (
token = 'ip4fjTQIO80CexrprZ+u4GgW4SVZeoEGd0S2jg88HQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)