UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNm7LcyNx1WHqdTXmvIjf87551yplZ9ezBqGzAuliM8='
WHERE
key_id = '87e80eb1be60f4aff2e2685c44290d4cac93d3dce2180285de2fab262b8681d0'
AND (
token = 'NNm7LcyNx1WHqdTXmvIjf87551yplZ9ezBqGzAuliM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)