UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UUp8NvTC8ctSFP44t+yrF/aMDPIJSmmGEKF7W6Jxfnc='
WHERE
key_id = 'af4e13989543bf996df1d79ce202f9927df119bbff7ae5a12cfd8a4546c808db'
AND (
token = 'UUp8NvTC8ctSFP44t+yrF/aMDPIJSmmGEKF7W6Jxfnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)