UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '58gE++ZXZ9+GGbUhVkBig5UKruiK94Zi9UDKaWMEPUQ='
WHERE
key_id = '196deb99dba290e143d3b3add45275b63e03da1db4944b74710e649d06cae886'
AND (
token = '58gE++ZXZ9+GGbUhVkBig5UKruiK94Zi9UDKaWMEPUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)