UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NogbY2tKCm/ZoVLK8c5sX/x5bA/hXO45JNTiJPOTgiA='
WHERE
key_id = 'a8efa8710d924735bb3efb11ad6b0cab36ca179822c1fc211051bd616913b15b'
AND (
token = 'NogbY2tKCm/ZoVLK8c5sX/x5bA/hXO45JNTiJPOTgiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)