UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8Ney3OrVG4SN2GJUbUKS+PQiW8zyvwDBtEKyLpAhf8='
WHERE
key_id = 'acb4a9396a0339ff22f20d918a3b7a84fd379a7c355b38d0280f3a3d803d144d'
AND (
token = 'n8Ney3OrVG4SN2GJUbUKS+PQiW8zyvwDBtEKyLpAhf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)