UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asSxyTfYeDCAykeXN1bECrZ14Wp5hWl4A9KnkdnCINY='
WHERE
key_id = 'c4c371ded17261d1ea987a1238b21774c4652f654b666c2ef77e92e2148277d1'
AND (
token = 'asSxyTfYeDCAykeXN1bECrZ14Wp5hWl4A9KnkdnCINY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)