UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0HHI6bOBFe8JOkH0XcQdtSvGKR/Nug7YfU0BfZL4hw='
WHERE
key_id = '49bcd4a70926a52569f6337e02dc01f82b27dff1e4d72a903162a3b4dbcfede3'
AND (
token = 'X0HHI6bOBFe8JOkH0XcQdtSvGKR/Nug7YfU0BfZL4hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)