UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9F5LaFdnwnT506iLxdHCitzBu/87Oe05ySGUD9jcMxk='
WHERE
key_id = 'e57daf1e47713376ec4dd92d944b89942e072a543636ca26a6c64047e012f878'
AND (
token = '9F5LaFdnwnT506iLxdHCitzBu/87Oe05ySGUD9jcMxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)