UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NUph3jBrcMb5a8s/VlJUGV/xCuj0g8xAeam69EB+rU='
WHERE
key_id = '0c16961d5213f4c235936e92734e47c5bfd22c3aa448b70a643ab762b2899baf'
AND (
token = '/NUph3jBrcMb5a8s/VlJUGV/xCuj0g8xAeam69EB+rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)