UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KdIi0OP2pRjuFfIM1chD9ZTjrPwighuxY+bhjTqO7Kg='
WHERE
key_id = '7978f6cca21a4252234f57667642b6b18c14709ed574db12ad765ccb7c5e561c'
AND (
token = 'KdIi0OP2pRjuFfIM1chD9ZTjrPwighuxY+bhjTqO7Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)