UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xniHkzAsdASGqO6fx18dJNPMTq4da1Yl2pkVwGXXK8s='
WHERE
key_id = 'c9fd0d9106dbcd84c8380e7945c51677e4028ba0b6f6240914094a3be184b8fc'
AND (
token = 'xniHkzAsdASGqO6fx18dJNPMTq4da1Yl2pkVwGXXK8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)