UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zosMyrozfbV/rrhV1MzssjugEcTh5qtZMY8Y+Hyq98M='
WHERE
key_id = '8de9568b5f6eaafd28cba6c320586ba996006ee817e88c832a48744e55ebf7d1'
AND (
token = 'zosMyrozfbV/rrhV1MzssjugEcTh5qtZMY8Y+Hyq98M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)