UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KuaBGpmklGwCQpCzE7iQwV0IKjZWoHE849eCdMsaBU='
WHERE
key_id = '8040d7426e1246a6d12c925671e79574a30d000cd5293ebb7a7407b657446b98'
AND (
token = '7KuaBGpmklGwCQpCzE7iQwV0IKjZWoHE849eCdMsaBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)