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