UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZXcGB59VSpm16+/cspfv3SQXYGcUXd+9XxFaro6lSB8='
WHERE
key_id = '5f0040a9065b3257e546120126a7e8d00674fca4a79770bf6ec5bac841cf80f9'
AND (
token = 'ZXcGB59VSpm16+/cspfv3SQXYGcUXd+9XxFaro6lSB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)