UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bs8WMlX95M67w12IBZ8H+oQzDYoIS5WEfVwvamL+iqI='
WHERE
key_id = '12efae32e8c5c26abf1f0535c7c68c44c2f92c77a950f1363b832e406cace3af'
AND (
token = 'bs8WMlX95M67w12IBZ8H+oQzDYoIS5WEfVwvamL+iqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)