UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nyp2/VzEMiGErINJzHHm6nb40qKpTQRZNbHt/uFYR8Q='
WHERE
key_id = '645876053ca097826b05755252f1e4ab49bca76af6289c12458eea816c0d5f45'
AND (
token = 'Nyp2/VzEMiGErINJzHHm6nb40qKpTQRZNbHt/uFYR8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)