UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n0pCpZ8D2Yd7bstQzdDbRkZ5t42pm1lZbGHs2dpkaa8='
WHERE
key_id = '17d3648f4a5f6a9c45b25b26056244152fd40e251fff93a56694c1297fef52fd'
AND (
token = 'n0pCpZ8D2Yd7bstQzdDbRkZ5t42pm1lZbGHs2dpkaa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)