UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0PlyTKlVgHbjTSRYm/ubmPFsthl+UfeyvvXjWXOerE='
WHERE
key_id = 'e438fada1143d18acc39b2d532df5b4a3ffc7be812f69adb858b0b2101891b03'
AND (
token = 'k0PlyTKlVgHbjTSRYm/ubmPFsthl+UfeyvvXjWXOerE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)