UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYWCUK/0523inVg1sdIZ14xSzvs69kmvueXAn/ljCMY='
WHERE
key_id = 'b4aed66dec8392b9acf4a48309c13180d81100d0a5ae19ccf1e9fbfa79359d30'
AND (
token = 'lYWCUK/0523inVg1sdIZ14xSzvs69kmvueXAn/ljCMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)