UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3BsV79aeS1P4h7ImtmJ+GppR10wTz4Tw3PhYjeQOdw='
WHERE
key_id = 'd062f83131cee7406c60705e89b987ac6a216ba2f996476675d322006fbdf58a'
AND (
token = 'D3BsV79aeS1P4h7ImtmJ+GppR10wTz4Tw3PhYjeQOdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)