UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hK0EzeSgGtGt3b7YmHFQr4SsTnbtK924e/vvy9vdiA='
WHERE
key_id = '9279a525f4900f5cefed0dae16e5badc3f318d63ff540feb4171b3da4e7fe19d'
AND (
token = '7hK0EzeSgGtGt3b7YmHFQr4SsTnbtK924e/vvy9vdiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)