UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zssWTITy9qu3BmVWxITiDCsFGCNx8Ooxm+pwS8lCrbI='
WHERE
key_id = '0427e93f8afbfd4d1c029dd4c7be7603603742e0be63c9859a33bfb83c7a5539'
AND (
token = 'zssWTITy9qu3BmVWxITiDCsFGCNx8Ooxm+pwS8lCrbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)