UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hv9GxkIUi5Ve7VGUhWb+ky1+KGzVgltxw+nNIUv9B68='
WHERE
key_id = '6217597d97c8171de42dae68bb3f53b432acd789fe416e41ef01e93499520fd5'
AND (
token = 'hv9GxkIUi5Ve7VGUhWb+ky1+KGzVgltxw+nNIUv9B68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)