UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBwCIi6ZA2ZpfAnsd4XmbvjQoqhYrIKsKmXBG8hcpgw='
WHERE
key_id = '513cd18812b6c743d13db491b251026059af2d1f527333d2ae2bfb2c86b89c04'
AND (
token = 'HBwCIi6ZA2ZpfAnsd4XmbvjQoqhYrIKsKmXBG8hcpgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)