UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cYxYo0Z795+8g0q+9IpzdbOPrhn0u+z0L/CvSdz+Awg='
WHERE
key_id = 'f3e8d56ef2626dc8e9391ec8dc49d685ee6ac4f4152202fd2fcec4d0d47d5c4a'
AND (
token = 'cYxYo0Z795+8g0q+9IpzdbOPrhn0u+z0L/CvSdz+Awg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)